Interview Questions

1. How many types of dimension are possible in SSAS?

Options:

a. Four

b. Five

c. Six

d. Seven

Reveal Answer

2. Define dimension usage in SSAS Cube?

Options:

a. To maintain cube data size

b. To know the relationships between dimensions and fact

c. To build business logic

d. None

Reveal Answer

3. Define role play dimensions?

Options:

a. One dimension used multiple times in the cube

b. One dimension used in different cubes

c. Shared across cubes

d. None

Reveal Answer

4. In which scenario, you would like to go for materializing dimension?

Options:

a. To increase spee

b. To decrease memory size

c. Both

d. None

Reveal Answer

5. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. You get the Duplicate Key error when you operate the Analysis Services Database. You should alter the Error Configuration attribute in order to make processing run normally. Which is the correct answer?

Options:

a. You should alter the Dynamic Management View (DMV)

b. You should alter the Local Group

c. You should alter the dimension

d. You should alter the Transactions Log

Reveal Answer

6. When you include a many-to-many dimension, the following rules apply?

Options:

a. You must add the intermediary measure group

b. You must add the entire many-to-many dimension

c. You must add the entirety of all dimensions common to the two measure groups involved in the many-to-many relationship

d. All of the mentioned

Reveal Answer

7. What are the different types of Hierarchies?

Options:

a. Natural Hierarchy

b. Unnatural Hierarchy

c. Balanced Hierarchy

d. Unbalanced Hierarchy

Reveal Answer

8. How to disable the attribute Hierarchy?

Options:

a. Attribute Hierarchy Enabled: False

b. Attribute Hierarchy: False

c. Attribute Hierarchy Enabled: True

d. None of these

Reveal Answer

9. Which type of property determines whether data for parent members should be displayed?

Options:

a. Members with Data Property

b. Naming Template Property

c. All the above

d. None of these

Reveal Answer

10. The attribute which identifies the parent of a dimension member is called________?

Options:

a. Parent Key Attribute

b. Member Key Attribute

c. None of these

Reveal Answer

Interview Questions and Answer

1. How many types of dimension are possible in SSAS?

2. Define dimension usage in SSAS Cube?

3. Define role play dimensions?

4. In which scenario, you would like to go for materializing dimension?

5. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. You get the Duplicate Key error when you operate the Analysis Services Database. You should alter the Error Configuration attribute in order to make processing run normally. Which is the correct answer?

6. When you include a many-to-many dimension, the following rules apply?

7. What are the different types of Hierarchies?

8. How to disable the attribute Hierarchy?

9. Which type of property determines whether data for parent members should be displayed?

10. The attribute which identifies the parent of a dimension member is called________?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources